<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN" 
    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
    <class name="cn.firstsoft.modules.emp.domain.EmpWorkExperience" table="emp_work_experience">

       <id name="id" type="integer">
            <column name="id" />
            <generator class="native" >
				       <param name="sequence">EMP_WORK_EXPERIENCE_ID_SEQ</param>
            </generator>
        </id>

        <property name="workUnit"  type="string">
             <column name="work_unit" length="50"/>
        </property>

        <property name="startDate" type="timestamp">
            <column name="start_date" length="23"/>
        </property> 
        
        <property name="endDate" type="timestamp">
            <column name="end_date" length="23"/>
        </property>

        <property name="workTime" type="double">
            <column name="work_time" length="23"/>
        </property>

        <property name="duty"  type="string">
             <column name="duty" length="50"/>
        </property>

        <property name="wngageWork"  type="string">
            <column name="wngage_work" length="23"/>
        </property>

        <property name="leaveCause" type="string">
             <column name="leave_cause" length="250"/>
        </property>

        <property name="proveMan"  type="string">
             <column name="prove_man" length="250"/>
        </property>

        <property name="linkAddr"  type="string">
           <column name="link_addr" length="100"/>
        </property>

        <property name="linkTel" type="string">
           <column name="link_tel" length="50"/>
        </property>

        <many-to-one name="employee" class="cn.firstsoft.modules.emp.domain.Employee" fetch="select">
            <column name="emp_id"/>
        </many-to-one>

    </class>

</hibernate-mapping>
